Editing XML Index General

Type
Choose the index type: Nonclustered, Clustered, XML or Spatial

Table/View
Must be Table.

Table Name
Select a table.

XML Column
Select the xml column on which the index is based.

XML Index Type

PRIMARY
A clustered index is created with the clustered key formed from the clustering key of the user table and an XML node identifier.

PATH secondary
Create a secondary XML index on columns built on path values and node values in the primary XML index. In the PATH secondary index, the path and node values are key columns that allow efficient seeks when searching for paths.

VALUE secondary
Create a secondary XML index on columns where key columns are (node value and path) of the primary XML index.

PROPERTY secondary
Create a secondary XML index on columns (PK, path and node value) of the primary XML index where PK is the primary key of the base table.

Primary XML index
Specify the primary XML index to use in creating a secondary XML index.